All Questions
224 questions
4votes
4answers
257views
how can CQRS improve performence when we have to duplicate the writes
I was reading about CQRS, and from what I understand, it separates reading from writing by using two databases: one for queries (reading) and another for commands (writing). However, I don’t quite get ...
4votes
7answers
2kviews
Should there be one-to-one relationship between DAOs and tables?
Should there be a one-to-one relationship between DAOs and tables? For example, should only one DAO communicate with a given table? Our data layer is kind of flawed, e.g. we have a MAN table that ...
- 1,523
3votes
4answers
731views
How much better is using quad trees than simple relational database for storing location data?
I want to store and find back driver location data in the standard design uber/lyft problem. I was researching about possible system design. Several videos and tutorials usually describe storing ...
- 169
0votes
2answers
108views
Service classes that only forward to DAO
I've seen service classes that do nothing except forwarding calls to DAO classes. E.g. userService.save(user) would simply call userDao.save(user) I heard the argument that some day in the future, a ...
- 1,523
11votes
8answers
7kviews
What is the advantage of log file rotation based on file size?
I understand that log file rotation is changing the log file you used when (1) one gets big enough or (2) at EOD, but I'm not sure I understand the reason for (1). I have never had any issues with ...
0votes
1answer
85views
Design a sequential processing of records
About 10 to 15 records are processed per day with the time interval of 5 minutes between each record. System A inserts a record in DB and sends id of that record to active mq. System B Listener ...
- 119
0votes
1answer
83views
Creating Controllers and Repositories without corresponding Models
I have to create a system to interview people on a few topics where they have to answer both objective and discursive questions, where questions may change between interviews. I structured the ...
- 111
0votes
1answer
2kviews
How do Repository and Data Mapper patterns work together?
I've seen a variety of discussions talking primarily about the question of the difference or not between the Repository and Data Mapper persistence system design patterns; but I think I have a decent ...
-1votes
3answers
620views
Is it better to override methods in classes or make methods general?
I am creating the backend of a microservice that will serve as a tool to see in real time how the company's employees are distributed by projects and what days they have assigned to each one. The ...
-1votes
3answers
322views
Is it ok to save all fields of an entity as a string if it should not be changed?
I have a complex object that has several fields can be updated until it is locked. Is it proper to save this locked entity as another entity which has no object child, only string data. complex object ...
- 109
0votes
2answers
342views
Architecture for worker pool with different task complexities and sizes of boxes
I'm sorry if I'm using any wrong terminology here. I'm trying to design an architecture where there can be big and small tasks (e.g. processing big or small images). Big tasks can only be handled by ...
- 311
2votes
4answers
358views
Database design - how to model database tables for similar objects - booleans / enums / inheritance / archived vs active
I only recently started to work with backends. My database is supposed to store information about maven-like artifacts. There are going to be applications and configuration artifacts. Now those ...
- 129
-1votes
2answers
523views
Should I store non-editable items lists in a database?
Relational database is mostly used for storing editable user data. But how about storing non-editable lists of information? Possible examples are: GUI-related: main menu items, selectbox options, ...
- 277
0votes
2answers
653views
Is it a good idea to use database sequential id as a key in external key-value storage?
I use Postgres database to store user information. Some of that information is sensitive so it was decided to store that information in Vault. The user table in Postgres has id's generated by a ...
- 167
0votes
1answer
44views
Design approach where to persist autocompletion suggestions
I am currently planning a movie recommendation application. Within this context, the user can fill out a form including different information (e.g. title, description, etc.). The new entry gets then ...
- 101
